            From:"Tuhin Bhaduri" <tuhinraja@yahoo.com>  Add to Address Book
            Date:Tue, 31 Aug 2004 23:36:25 -0700 (PDT)
            Subject:[kgec_kalyani] TCS Interview pattern(28-30 th Aug)

          
      Dear seniors and Friends and juniors....
      I am going to write 2 U a very eventful and obviously disgusting 
      experience of me.........
      Its TCS exam....
      On 28th Aug Morning
      Approximately 2500 student appear in the exam...Really there was so 
      mismanagement and misdeed in the TCS organization that I cant have 
      experienced ever...they gave time of 9.00am(at Techno India)..We were 
      present there within 8.30 am and they started there procedure of entrance 
      in 10.30 am but there was no discipline in the queue. Who can fight well 
      and have a good physic was succeed to make an entry But alas I have not 
      such capabilities....I was at the front part of the queue...But the 
      immense pressure coerced me to change my position. In the mean time due to 
      some healthy student's performance in the queue I just felled down to the 
      muddy road, my glass broke , dress soiled .....I was really confused that 
      whether I am going 4 interview or fighting.....After a long time (12.00 
      noon) ...police force came to bring the situation under control....Friends 
      there was no restriction of year of pass out.....who R willing 2 join the 
      TCS festival they all R welcome.......Then at last at 1.30 pm I was 
      succeed 2 enter to the Techno campus. We were verified by some young 
      people who r now trainees.........
       
       
      We were waited some time in the hall...the written exam started at 
      2.30pm...There was both on line and offline exam...My set was 'G'......I 
      prepared well in vocabs....So I can manage vocabs part....other wise set G 
      vocabs part was a little tough....Other section was just repetition of 
      previous questions....there was no psychometric test....
       
      Result declared in 5.30 pm....I was selected........We were told 2 go 2 a 
      particular room for verification and filling a form..........Again we saw 
      how TCS can make a mess in management....
      There was no identification who qualified for written exam and who 
      not.....lots of students were thronged to the hall for being instructed 
      for waiting....At 8.00pm they verified my form...and told me that my 
      interview would be in 30th Aug from 4.00pm.........
       
       
      I prepared well in Data Structure, DBMS, C, C++, Software Engg...But not 
      so much in networking....
      On 30 th Aug Noon:
      I was present in the TCS building(Interview venue) within 
      3.00pm...Suddenly my friend Bishal (Now TCS employee) called me by my 
      name...I thought I was called 4 waiting 4 interview bcoz then it was 
      3.40pm ....Anyway he told me that "tor panel ta khub chaper...Monehochhe 
      holona...Amar kichhu korar nei tui chaper panel a pore gechhis...."  
      ..Then I was so confused that I told nothing...
      Previously I heard that there was a madam who were asking a lot tough 
      questions and rejected almost each one in the interview...Anyway my 
      preparation was well...so I was not bothered at allI entered to the 
      Interview panel. There were many interviewers distributed in the same room 
      ...Each pairs of interviewers took interviews of different fresheres... My 
      interviewers were at the corner of the table....now my original story 
      begins...
       
       
      I went to the room and took a sit........After that without saying 
      anything the lady and the very young guy just were staring to me for three 
      minutes. and the guy made some peculiar gestures...I thought that they 
      expected to start me first....then I started myself...I just introduced 
      myself...they asked me 4 the cause for gap in year...I said I studied Comp 
      Sc in MCET after H.S...But due 2 lack of infrastructure I reappeared 4 JEE 
      and admitted to KGEC...
      They told then U have 5 years of comp background...And laughed
      I completed my gist introduction...but the guy told me to continue 
      further...I started 2 elaborate my hobbies...I told them...that designing 
      web site is my one of the hobbies....and mentioned them that I have a 
      personal website...http://neonate.netfirms.com....
      The man said how many time do u Spear by designing web pages?
      I said there is no fixed timewhen ever I get time and have a good mood I 
      just design web pages He said how many times? I compelled 2 say that near 
      about 1 to 2 hours
       
      He asked the purpose of my pagesI said some personal information, some 
      educative informationHe said then it is merely ur personal homepage.
      I said yes
       
      They said that is there any feedback page or not.  In my web pages...I 
      said yes
      He: how do U maintain Ur data base?
      I said .There is a backend database in Access with the help of MS Access 
      .I maintained tables in accessing the data that any user put in the feed 
      back form...
      He said what about the data base connectivity?
      I said I just connect database with the front end ASP. That is front end 
      is ASP and backend is ACCESS...
      Then he said how can U connect ur database?
      I said r u asking about the code by which I establish the connection...
      He: No, No I said about connectivityDatabase connectivity...
      I: please repeat.
      He: How can U connect database?
      I: In html page by writing code we can connectand there is readymade 
      option in Microsoft front page by which U can create connectivity with the 
      database...
      He: what?
      I: MS FrontPagethere is readymade option...
      He: have u done with front page or ASP
      I: Firstly I started with ASP but there was some problem in 
      connectivityThen I have done this work with the help of FrontPage...there 
      is nice option to do such things...
      She: Then U R not succeed in ASP coding...
      I: In particular that case.
      He: In a particular Network how computer interacts?
      I: I said the basic net work concept.
      He: What is the protocol used in that? If two computers are connected in a 
      network then what is the protocol used in that?
      I: There are many types of protocol that can be used...
      He: example...
      I: ftp.
      He: Will U use FTP to communicate from one computer to another?
      I: Yes FTP can be used... If U give me any machine that is in networkwith 
      the help of ftp I can copy some content of one m/c to another.
      (He is giggling. and said R U sure? I was confused)
      He: what is abbreviation of ftp? In which layer it works?
      I: File Transfer Protocol. Application Layer
      He: Ok...What is the basic protocol?
      I: thinking.
      He: Do U know the name TCP/IP
      I: Yes. That is the basic protocol.
      He: TCP/IP is not basic protocol Its more than that.  Backbone of 
      protocol is a part of TCP/IP...How many layers in TCP/IP?
      I: 5 and give their name..
      They asked some practical oriented qs from Network. But I cant understand 
      what they mean
      They were not satisfied about my network knowledgebut I have not 
      mentioned Network as my subject both in their form and my CVso I said 
      that it is not my favorite subject...and those parts R not fully covered 
      in my syllabus...I have only theoretical knowledge
      They said u have 5 years background of comp knowledgeU dont know such 
      basic thingThen he started 2 ask Qs from OS...
      I astonished to hear 5 yearsbut they explain me that I had one year comp 
      Course in Berhampore MCET
      He: What types of Os do U ever encounter?
      I said ...DOS, WINDOWS and A LITTLE bit UNIX
      He: What type of WINDOWS?
      I saidwin-98, win 2000, Win 2003 etc
      He: For Win 2003 is it a net work OS of a mere client version?
      I said it is a Network enabled OS.
      He: Why?
      I: There R facilities for communicating through net work where we can 
      install win2003 in the server machine as well as client M/C in a 
      particular net work..
       
      He: What facilitates Win2003 as a net work enabled OS?
       
      I: There  R  IIS(Internet Information Service) in win 2003 .It is  
      embedded in it by which we can upload a site ,access the site and 
      virtually we can get a real time environment.
       
      What R the services in the back when IIS run in a computer?
      I said actually I cant remember those services name.
      He said U don't know the service name but still U R using IIS.
      Then I said IIS is not within my syllabus. Personally I fill interested in 
      it and use that for experience a virtual real time server client 
      environment. And it is totally free with windows we need not install a 
      third party web server if we have win2000/win2003..
      Then he said is it free?
      I said yes it is shipped with windows2003.So if U have win2003 it is free 
      with that.
      Then he asked some qss on windows internal architecture but again I dont 
      understand what they meanReally their English pronunciation and spoken 
      power was very poor They both R very bad in English..
      Then the lady comes into the picture
      She: What is RDBMS?
      I: It is a subset of DBMSthat maintain codds rules, Based on some tables 
      which consist data and their relationsetc
      She: Is it a sub set of DBMS?
      I: yes.
      She: No, Its not subset...its a special kind of DBMS.
      I try 2 pursue what I want 2 mean But failed
      She: Properties of RDBMS?
      I: told..
      She: What is 3NF?
      I : I saidNo functional dependency among non key attributes
      She: why Normal Form Required?
      I: To remove redundancy, Inconsistency.etcTo avoid wastage of storage...
      She: What is inconsistency?
      I said about duplicity of datathen
      She: If we want 2 store the same data in different row...in RDBMS .is it 
      possible or not?
      I: We can enter but when we enter same data we introduce inconsistency in 
      the table...
      She: Say, is it possible or not?
      I: sometime possible sometime not.
      She: when possible when not?
      I: When data entry in different table leads 2 anomalies in some relation 
      then not possible Otherwise possible...
      She: what R the diff types of Relations?
      I: Do U want 2 know mapping cardinalitiesie... one 2 one, one 2 many, 
      many 2 many
      She: No U dont know...
      She: What are diff types of DBMS?
      I: Hierarchical, Semi structural (XML), Network, Distributed, Object 
      orientedetc
      She: I said DBMS
      I cant understand..what she means
      She: what is ER model?
      I: where distinguishable object or entities and the relations among them R 
      represented pictorially
      She: what is the difference between table and entity or column or 
      attribute?
      I: Two terms mean sameIn RDBMS we use term table and column
      She: then why R U using two terms?
      (I become confused!!!!!)
      She: What is super entity?
      I: dont know
      She: what is smart query?
      I: dont know
      She: What R the diff types of query?
      I: declarative and procedural (they R not satisfied)
      She: What is the diff between truncate and delete?
      I: dont know (at that moment I guessed sth)
      She: What is join?
      I: It combination of selection and Cartesian product.
      She:  There R two tables
       Emp[emp name,emp no,Dept no]   and   Dept[Dept no,Dept name]
      U have to select all emp name,emp no and Dept name....Is it possible?
      Then write query...
      I: Start 2 write
      She: Is it at all possible?
      I: Try 2 explain..
      She said that just say yes or no ...I said yes
      She: What is recursive join?
      I: dont know
      She: If there R some same rows in a same table is it possible to retrieve 
      those from the table?
      I: U want 2 retrieve those tuple s
      She got annoyed to hear the term tuple.I dont know why?
      I said yes and write the query.then she said same data means it may be 
      1/one and 3/three..Again I cant make any meaning.
       
       
      In this way with some peculiar qss the interview ended.They dont even 
      ask me about my favorite subjects and my projectswhich was very formal 2 
      any candidates interviewwhen I started 2 describes my project 
      spontaneously they stop me at the beginning I didnt expect my name as a 
      qualified candidate due 2 their expressionsAnd that was happenedBishal 
      conveyed the message of disqualifying me
       
       
      Now friends and seniors  please give me suggestion what should I do at 
      this momentFirstly I was disqualified in HR round in the same TCSNow in 
      Techni round What should I do 2 improve myself
      And how can I handle these type of stress interviewsfriends and seniors  
      I really need u r valuable comments and suggestionsIf u know the proper 
      answer of what I was asked in technique round plz send me the answers.I 
      am waiting for that
                                                                                 
                                         Yours Tuhin
     